{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","REG"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,1,19,8],[18,1,18,8],[3,1,3,2],[6,6,12,11]]}
[]
[null,"Yellow Card Report for Vision",null,null,null,null,"Information"]
[null,"This will simply import all yellow card forms created in Vision whether sent or saved",null,null,null,null,"Registration Status"]
[null,"Search Date Range",null,null,null,null,"Active Patients = Applied and Permanent"]
[null,"START","END",null,"Registration Status",null,"None = All patients regardless of status"]
[null,{"$f":"EOMONTH(TODAY(),-13)+1","v":"2016-01-01"},{"$f":"TODAY()","v":"2017-01-06"},null,"ACTIVE PATIENTS",null,"Note:"]
[null,null,null,null,null,null,"Yellow Card data is initiated in Vision by ticking \"Send Yellow Card\" within the Drug Allergy and Intolerance entity.\nIf \"Send Yellow Card\" has not been selected at some point it is recorded as a normal Drug Allergies and Intolerance and therefore will not be displayed in this workbook."]
[]
[]
[]
[null,"You must be signed into Vision before clicking Import button"]
[null,"This workbook will minimise while compiling and maximise when complete"]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM500 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[]
[]
[null,"Last updated: 04/01/2017 v1.0"]
[null,"Written by: Bradley Sieve"]

{"sheet":"REG","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code"]
["ACTIVE PATIENTS"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["NONE"]